[dbo].[BAEOrderAttributeGetLastSortOrderFromLookup]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEOrderAttributeGetLastSortOrderFromLookup

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@OrderProductID	int	4

SQL Script

create procedure [dbo].[BAEOrderAttributeGetLastSortOrderFromLookup] @OrderProductID int as
SELECT    MAX(SortOrder) SortOrder
    FROM    OrderSuperProductAttributeLookup
    WHERE    OrderProductID = @OrderProductID;

GO

Uses

[dbo].[OrderSuperProductAttributeLookup]
dbo